Stored Procedures [dbo].[BAEPostUpdateWrapup]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@userIDvarchar(10)10
@birthDatevarchar(20)20
@excludeMailbit1
@SICCodevarchar(10)10
SQL Script
create procedure [dbo].[BAEPostUpdateWrapup] @userID varchar(10),
     @birthDate varchar(20),
     @excludeMail bit,
     @SICCode varchar(10) as
IF(@birthDate  <> '')
        BEGIN
            UPDATE Name
            SET BIRTH_DATE = @birthDate, EXCLUDE_MAIL = @excludeMail, SIC_CODE = @SICCode
            WHERE ID = @userID;
        END
    ELSE
        BEGIN
            UPDATE Name
            SET BIRTH_DATE = NULL, EXCLUDE_MAIL = @excludeMail, SIC_CODE = @SICCode
            WHERE ID = @userID;
        END

GO
Uses